
USE master
GO

CREATE DATABASE GPN
ON 
( NAME = 'GPN_dat',
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\GPN_dat.mdf',
   SIZE = 10,
   MAXSIZE = 50,
   FILEGROWTH = 5 )
LOG ON
( NAME = 'GPN_log',
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\GPN_log.ldf',
   SIZE = 5MB,
   MAXSIZE = 25MB,
   FILEGROWTH = 5MB )
GO

use GPN;
exec sp_addlogin 'gpn', 'desarrollo', 'GPN', NULL, NULL, NULL ;
exec sp_droplogin 'gpn'
exec sp_helplogins 'gpn'
GO

use GPN;
exec sp_changedbowner 'gpn'
GO


